What is the Custom View Page?

You can create custom views for your mart on the SQL Server database. These views can be registered in xMart and used like tables.

There is a page that displays information on both the registered and unregistered views.

Where is the Custom View Page?

There is a link in the Models Menu but the user will need MODEL_UPDATE permission to use it.

Custom Views Location

This will give a list of views created on the mart.

Custom Views List

Registered View Options

Clicking on a registered view will offer a number of options.

Fields

You can see a list of fields which will be returned when the view is run.

Custom Views Menu Fields

Custom Views Fields

Definition

The view definition can be seen here but cannot be changed.

Custom Views Menu Definition

Custom Views Definition

History

xMart keeps a history of changes for both registered and unregistered views. This functionality allows you to look at the history of a view.

Custom Views Menu History

If you click on a version, you can see the date the view changed underneath the version number.

Custom Views History

You can compare two versions of the view to see what has changed.

Custom Views History Compare

Properties

You can see and edit the properties of a view.

Custom Views Menu Properties

This brings up the same pop-up as you would get if you went to Admin\Catalog and clicked on the pencil icon to edit a view’s properties.

Custom Views Properties

Unregister

A view can be unregistered from here.

Custom Views Menu Unregister

Custom Views Unregister

Data

The data can be viewed directly from here

Custom Views Menu Data

This takes you to the Data page

Custom Views Data

Unregistered View Options

For unregistered views, there are almost all of the same options except that there are no Properties or Data available.

Custom Views Unregistered Menu

Register View

Views can be registered from here.

Custom Views Menu Register

This takes you to the same dialogue box as you would get if you went to the Catalog Page and pressed the + next to the Custom Views.

Custom Views Register